I have a SQL destination table with foll columns. CREATE TABLE [dbo].[Staging_JCDS_PM_CM_Initial]( [Name] [nvarchar](255) NULL, [DateValue] [datetime] NULL, [TimeValue] [timestamp] NULL ) ON [PRIMARY] I have ths table as SSIS - OLEDB destination. Source is from a CSV file. I get an error on TimeValue column saying "Failure inserting into the read only column "TimeValue" Please help to solve this .... Thanks in Advance. Added: Temporarily I have changed datatype Timestamp to varchar(50). and i use convert(varchar,TimeValue, 108) to convert varchar to Timestamp.

1) Is there a default on TimeValue above and it is missed in the script above. 2)If there is a default and trying to insert , this error maight appear.Happy to help! Thanks. Regards and good Wishes, Deepak.

1) Is there a default on TimeValue above and it is missed in the script above. 2)If there is a default and trying to insert , this error maight appear. Happy to help! Thanks. Regards and good Wishes, Deepak. Nope. There is no default value.

The SQL Server timestamp data type is a binary number maintained by the SQL Server engine. Don't confuse it with the SQL Server datetime or the SQL-92 standard timestamp. Columns with a data type of Timestamp are readonly.Jeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt)

timestamp is a data type that exposes automatically generated binary numbers, which are guaranteed to be unique within a database http://msdn.microsoft.com/en-us/library/aa260631(SQL.80).aspxHappy to help! Thanks. Regards and good Wishes, Deepak.

The SQL Server timestamp data type is a binary number maintained by the SQL Server engine. Don't confuse it with the SQL Server datetime or the SQL-92 standard timestamp. Columns with a data type of Timestamp are readonly. Jeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt) OOps. Thnks for being my eye opener !!!

No problem and thanks for marking your question as answered.Jeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt)